package com.android.whatsblue.dao;

import android.provider.BaseColumns;

public interface Constants extends BaseColumns{
	
	public static final String TABLE_CONTACTOS = "CONTACTOS";
	public static final String TABLE_CHAT = "CHAT";
	
	//Columnas tabla CONTACTOS
	public static final String MAC = "mac";
	public static final String NOMBRE = "nombre";
	public static final String ESTADO = "estado";
	
	//Columnas Tabla CHATS
	public static final String FECHA = "fecha";
	public static final String HORA = "hora";
	public static final String CONVERSACION = "conversacion";
	
	//Queries de la base de datos
	public static final String CREATE_TABLE_CONTACTOS = "CREATE TABLE "+TABLE_CONTACTOS+" ( "+MAC+" STRING PRIMARY KEY, "+NOMBRE+" STRING, "+ESTADO+" STRING);";
	public static final String CREATE_TABLE_CHAT = "CREATE TABLE "+TABLE_CHAT+" ( "+MAC+" STRING PRIMARY KEY, "+FECHA+" DATE, "+HORA+" TIMESTAMP, "+CONVERSACION+" STRING);";
	public static final String GET_ALL_CONTACTO = "SELECT rowid _id, * FROM "+TABLE_CONTACTOS+" ORDER BY "+NOMBRE;
	public static final String GET_CHAT_CONTACTO = "SELECT "+FECHA+" FROM "+TABLE_CHAT+" WHERE "+MAC+" = ?";
	public static final String GET_CHAT_CONTACTO_DIA = "SELECT * FROM "+TABLE_CHAT+" WHERE "+MAC+" = ? AND "+FECHA+" = ?" ;
	public static final String SET_CONTACTO = "";
	public static final String SET_CHATS_CONTACTO = "";
	public static final String DELETE_CHAT = "";
	public static final String DELETE_CONTACTO_WHERE = " "+MAC+" LIKE ? AND "+NOMBRE+" like ? ;";
	public static final String DELETE_TABLE_CONTACTOS = "DROP TABLE IF EXITS "+TABLE_CONTACTOS;
	public static final String DELETE_TABLE_CHAT = "DROP TABLE IF EXITS "+TABLE_CHAT;
	
}
